Used to constrain the considered lock granularities for an index 用于約束經(jīng)過考慮的索引鎖粒度。
You can choose to change the locking granularity for some operations 您可以選擇更改某些操作的鎖定粒度。
Lock granularity and hierarchies 鎖粒度和層次結(jié)構(gòu)
Index locking granularity 索引鎖定粒度
For more information about configuring the locking granularity for an index , see 有關為索引配置鎖定粒度的詳細信息,請參閱
Use caution , because changing locking granularity can have adverse effects on concurrency 請慎用此操作,因為更改鎖定粒度可能對并發(fā)性有負面影響。
The database engine can dynamically choose the level of lock granularity based on the optimizer s estimate of the number of rows a transact - sql statement will reference 數(shù)據(jù)庫引擎可以根據(jù)優(yōu)化器估計的transact - sql語句可能引用的行數(shù),動態(tài)地選擇鎖粒度級別。